Overview

Dataset Statistics

Number of Variables 12
Number of Rows 25711
Missing Cells 0
Missing Cells (%) 0.0%
Duplicate Rows 0
Duplicate Rows (%) 0.0%
Total Size in Memory 2.4 MB
Average Row Size in Memory 96.0 B
Variable Types
  • DateTime: 1
  • Numerical: 11

Dataset Insights

CUM_VAL_1 is skewed Skewed
CUM_VAL_2 is skewed Skewed
CUM_VAL_3 is skewed Skewed
CUM_VAL_4 is skewed Skewed
CUM_VAL_5 is skewed Skewed
TOTAL_AMOUNT is skewed Skewed

Variables


DT

datetime

Distinct Count 25661.9176
Approximate Unique (%) 99.8%
Missing 0
Missing (%) 0.0%
Memory Size 201.0 KB
Minimum 2016-11-01 00:00:00
Maximum 2019-10-08 07:00:00

CUM_VAL_1

numerical

Approximate Distinct Count 18515
Approximate Unique (%) 72.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 401.7 KB
Mean 2.1578e+07
Minimum 1
Maximum 4.6842e+07
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • CUM_VAL_1 is skewed left (γ1 = -0.2662)

Quantile Statistics

Minimum 1
5-th Percentile 1320
Q1 6592
Median 2.8632e+07
Q3 3.6321e+07
95-th Percentile 4.3787e+07
Maximum 4.6842e+07
Range 4.6842e+07
IQR 3.6315e+07

Descriptive Statistics

Mean 2.1578e+07
Standard Deviation 1.7588e+07
Variance 3.0932e+14
Sum 5.548e+11
Skewness -0.2662
Kurtosis -1.6557
Coefficient of Variation 0.8151
  • CUM_VAL_1 is not normally distributed (p-value 1.7727195079816e-23)

CUM_VAL_2

numerical

Approximate Distinct Count 17459
Approximate Unique (%) 67.9%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 401.7 KB
Mean 4.3898e+07
Minimum 1
Maximum 8.3182e+07
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • CUM_VAL_2 is skewed left (γ1 = -0.4218)

Quantile Statistics

Minimum 1
5-th Percentile 1344
Q1 6580
Median 6.4165e+07
Q3 7.2735e+07
95-th Percentile 8.0447e+07
Maximum 8.3182e+07
Range 8.3182e+07
IQR 7.2728e+07

Descriptive Statistics

Mean 4.3898e+07
Standard Deviation 3.4832e+07
Variance 1.2133e+15
Sum 1.1287e+12
Skewness -0.4218
Kurtosis -1.7324
Coefficient of Variation 0.7935
  • CUM_VAL_2 is not normally distributed (p-value 6.197570179039232e-22)

CUM_VAL_3

numerical

Approximate Distinct Count 17461
Approximate Unique (%) 67.9%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 401.7 KB
Mean 4.5818e+07
Minimum 1
Maximum 8.6964e+07
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • CUM_VAL_3 is skewed left (γ1 = -0.4203)

Quantile Statistics

Minimum 1
5-th Percentile 1320
Q1 6536
Median 6.6775e+07
Q3 7.6048e+07
95-th Percentile 8.4124e+07
Maximum 8.6964e+07
Range 8.6964e+07
IQR 7.6042e+07

Descriptive Statistics

Mean 4.5818e+07
Standard Deviation 3.6364e+07
Variance 1.3223e+15
Sum 1.178e+12
Skewness -0.4203
Kurtosis -1.7316
Coefficient of Variation 0.7937
  • CUM_VAL_3 is not normally distributed (p-value 5.967322741879091e-22)

CUM_VAL_4

numerical

Approximate Distinct Count 18510
Approximate Unique (%) 72.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 401.7 KB
Mean 2.159e+07
Minimum 1
Maximum 4.2715e+07
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • CUM_VAL_4 is skewed left (γ1 = -0.3787)

Quantile Statistics

Minimum 1
5-th Percentile 1330
Q1 6556
Median 3.0683e+07
Q3 3.5845e+07
95-th Percentile 4.1045e+07
Maximum 4.2715e+07
Range 4.2715e+07
IQR 3.5839e+07

Descriptive Statistics

Mean 2.159e+07
Standard Deviation 1.7253e+07
Variance 2.9766e+14
Sum 5.551e+11
Skewness -0.3787
Kurtosis -1.7117
Coefficient of Variation 0.7991
  • CUM_VAL_4 is not normally distributed (p-value 1.289008811564706e-22)

CUM_VAL_5

numerical

Approximate Distinct Count 22063
Approximate Unique (%) 85.8%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 401.7 KB
Mean 4.6404e+06
Minimum 1
Maximum 1.1264e+07
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • CUM_VAL_5 is skewed left (γ1 = -0.1201)

Quantile Statistics

Minimum 1
5-th Percentile 1296.5
Q1 6506.5
Median 5.8041e+06
Q3 7.7362e+06
95-th Percentile 1.0161e+07
Maximum 1.1264e+07
Range 1.1264e+07
IQR 7.7297e+06

Descriptive Statistics

Mean 4.6404e+06
Standard Deviation 3.8771e+06
Variance 1.5032e+13
Sum 1.1931e+11
Skewness -0.1201
Kurtosis -1.5442
Coefficient of Variation 0.8355
  • CUM_VAL_5 is not normally distributed (p-value 9.32122993272853e-24)

USAGE_AMOUNT_1

numerical

Approximate Distinct Count 1650
Approximate Unique (%) 6.4%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 401.7 KB
Mean 1536.989
Minimum 440
Maximum 4420
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • USAGE_AMOUNT_1 is skewed right (γ1 = 0.9347)

Quantile Statistics

Minimum 440
5-th Percentile 736
Q1 1112
Median 1432
Q3 1876
95-th Percentile 2644
Maximum 4420
Range 3980
IQR 764

Descriptive Statistics

Mean 1536.989
Standard Deviation 593.0436
Variance 351700.7427
Sum 3.9518e+07
Skewness 0.9347
Kurtosis 0.9724
Coefficient of Variation 0.3858
  • USAGE_AMOUNT_1 has 582 outliers

USAGE_AMOUNT_2

numerical

Approximate Distinct Count 1041
Approximate Unique (%) 4.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 401.7 KB
Mean 1499.3506
Minimum 732
Maximum 3368
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • USAGE_AMOUNT_2 is skewed right (γ1 = 0.9446)

Quantile Statistics

Minimum 732
5-th Percentile 961.5
Q1 1192
Median 1440
Q3 1736
95-th Percentile 2232
Maximum 3368
Range 2636
IQR 544

Descriptive Statistics

Mean 1499.3506
Standard Deviation 406.7936
Variance 165481.0269
Sum 3.855e+07
Skewness 0.9446
Kurtosis 1.1371
Coefficient of Variation 0.2713
  • USAGE_AMOUNT_2 is not normally distributed (p-value 7.527215492149085e-06)
  • USAGE_AMOUNT_2 has 561 outliers

USAGE_AMOUNT_3

numerical

Approximate Distinct Count 1172
Approximate Unique (%) 4.6%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 401.7 KB
Mean 1590.4008
Minimum 664
Maximum 3824
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • USAGE_AMOUNT_3 is skewed right (γ1 = 0.8297)

Quantile Statistics

Minimum 664
5-th Percentile 932
Q1 1192
Median 1544
Q3 1888
95-th Percentile 2448
Maximum 3824
Range 3160
IQR 696

Descriptive Statistics

Mean 1590.4008
Standard Deviation 491.971
Variance 242035.4834
Sum 4.0891e+07
Skewness 0.8297
Kurtosis 0.9009
Coefficient of Variation 0.3093
  • USAGE_AMOUNT_3 is not normally distributed (p-value 2.6583348571182413e-08)
  • USAGE_AMOUNT_3 has 455 outliers

USAGE_AMOUNT_4

numerical

Approximate Distinct Count 966
Approximate Unique (%) 3.8%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 401.7 KB
Mean 945.3945
Minimum 382
Maximum 2208
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • USAGE_AMOUNT_4 is skewed right (γ1 = 1.0672)

Quantile Statistics

Minimum 382
5-th Percentile 563.5
Q1 700
Median 880
Q3 1100
95-th Percentile 1614
Maximum 2208
Range 1826
IQR 400

Descriptive Statistics

Mean 945.3945
Standard Deviation 321.181
Variance 103157.2624
Sum 2.4307e+07
Skewness 1.0672
Kurtosis 0.8973
Coefficient of Variation 0.3397
  • USAGE_AMOUNT_4 is not normally distributed (p-value 0.001636732169772681)
  • USAGE_AMOUNT_4 has 900 outliers

USAGE_AMOUNT_5

numerical

Approximate Distinct Count 1533
Approximate Unique (%) 6.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 401.7 KB
Mean 537.4504
Minimum 67
Maximum 1930
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • USAGE_AMOUNT_5 is skewed right (γ1 = 1.1171)

Quantile Statistics

Minimum 67
5-th Percentile 150
Q1 280
Median 431
Q3 728
95-th Percentile 1266
Maximum 1930
Range 1863
IQR 448

Descriptive Statistics

Mean 537.4504
Standard Deviation 345.5827
Variance 119427.4027
Sum 1.3818e+07
Skewness 1.1171
Kurtosis 0.6053
Coefficient of Variation 0.643
  • USAGE_AMOUNT_5 has 640 outliers

TOTAL_AMOUNT

numerical

Approximate Distinct Count 7511
Approximate Unique (%) 29.2%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 401.7 KB
Mean 6111.9646
Minimum 430
Maximum 65040
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • TOTAL_AMOUNT is skewed right (γ1 = 1.7777)

Quantile Statistics

Minimum 430
5-th Percentile 3459
Q1 4546
Median 5758
Q3 7306
95-th Percentile 9913.5
Maximum 65040
Range 64610
IQR 2760

Descriptive Statistics

Mean 6111.9646
Standard Deviation 2069.2709
Variance 4.2819e+06
Sum 1.5714e+08
Skewness 1.7777
Kurtosis 26.1529
Coefficient of Variation 0.3386
  • TOTAL_AMOUNT is not normally distributed (p-value 1.1196170372268585e-12)
  • TOTAL_AMOUNT has 507 outliers

Interactions

Correlations

Missing Values